package com.dingding.commonservice.core.city.sql;

/**
 * 
 * @ClassName: CitySQL 
 * @Description: 开通城市SQL类
 * @author YHQ
 * @date 2016年12月1日 下午3:26:47
 * @since V2.5.7
 * 
 */
public class CitySQL {

	/**
	 * @author YHQ
	 * @Description 获取开通城市列表
	 */
	public static final String GET_OPEN_CITY_LIST = "SELECT c.sysCityId AS cityId , c.cityName AS cityName FROM dd_sys_city c";
	
	/**
	 * @author YHQ
	 * @Description 获取开通城市列表
	 */
	public static final String GET_CITY_BY_CITYNO = "SELECT cityId, cityName, isServiceCity, cityNo FROM city WHERE cityNo = ?";
	
	/**
	 * @author hufan
	 * @Description 根据cityId获取开通城市
	 */
	public static final String GET_OPEN_CITY_BY_ID = "SELECT c.sysCityId AS cityId , c.cityName AS cityName FROM dd_sys_city c WHERE c.sysCityId = ?";
	
}
